<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateFitnessFormTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('fitness_form', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('title')->default('')->comment('标题');
            $table->string('user_id')->default('')->comment('用户id');
            $table->string('height')->default('0')->nullable()->comment('身高');
            $table->string('weight')->default('0')->nullable();
            $table->tinyInteger('arm_cir_left')->default('0')->nullable()->comment('左臂围');
            $table->tinyInteger('arm_cir_right')->default('0')->nullable()->comment('右臂围');
            $table->tinyInteger('side_head_zlw')->default('0')->nullable();
            $table->tinyInteger('side_head_qy')->default('0')->nullable();
            $table->tinyInteger('side_head_hy')->default('0')->nullable();
            $table->tinyInteger('side_cvb_zxz')->default('0')->nullable();
            $table->tinyInteger('side_cvb_qq')->default('0')->nullable();
            $table->tinyInteger('side_cvb_qz')->default('0')->nullable();
            $table->tinyInteger('side_pat_zlw')->default('0')->nullable();
            $table->tinyInteger('side_pat_nx')->default('0')->nullable();
            $table->tinyInteger('side_thv_zxz')->default('0')->nullable();
            $table->tinyInteger('side_thv_ht')->default('0')->nullable();
            $table->tinyInteger('side_thv_qz')->default('0')->nullable();
            $table->tinyInteger('side_thv_fgb')->default('0')->nullable();
            $table->tinyInteger('side_luv_zxz')->default('0')->nullable();
            $table->tinyInteger('side_luv_qq')->default('0')->nullable();
            $table->tinyInteger('side_luv_qz')->default('0')->nullable();
            $table->tinyInteger('side_ntp_zlw')->default('0')->nullable();
            $table->tinyInteger('side_ntp_qq')->default('0')->nullable();
            $table->tinyInteger('side_ntp_hq')->default('0')->nullable();
            $table->tinyInteger('side_sar_zlw')->default('0')->nullable();
            $table->tinyInteger('side_sar_cs')->default('0')->nullable();
            $table->tinyInteger('back_nec_zlw')->default('0')->nullable();
            $table->tinyInteger('back_nec_qq')->default('0')->nullable();
            $table->tinyInteger('back_nec_xz')->default('0')->nullable();
            $table->tinyInteger('back_sho_zlw')->default('0')->nullable();
            $table->tinyInteger('back_sho_yg')->default('0')->nullable();
            $table->tinyInteger('back_sho_zg')->default('0')->nullable();
            $table->tinyInteger('back_pat_zlw')->default('0')->nullable();
            $table->tinyInteger('back_pat_qq')->default('0')->nullable();
            $table->tinyInteger('back_pat_hsk')->default('0')->nullable();
            $table->tinyInteger('back_tlv_zlw')->default('0')->nullable();
            $table->tinyInteger('back_tlv_s')->default('0')->nullable();
            $table->tinyInteger('back_tlv_c')->default('0')->nullable();
            $table->tinyInteger('back_pel_zlw')->default('0')->nullable();
            $table->tinyInteger('back_pel_ycq')->default('0')->nullable();
            $table->tinyInteger('back_pel_zcq')->default('0')->nullable();
            $table->tinyInteger('back_knj_zlw')->default('0')->nullable();
            $table->tinyInteger('back_knj_xwfm')->default('0')->nullable();
            $table->tinyInteger('back_knj_xnf')->default('0')->nullable();
            $table->tinyInteger('back_fot_yzg')->default('0')->nullable();
            $table->tinyInteger('back_fot_bpz')->default('0')->nullable();
            $table->tinyInteger('back_fot_gzg')->default('0')->nullable();
            $table->string('side_img')->nullable()->comment('侧面观图片');
            $table->string('back_img')->nullable()->comment('背后观图片');
            $table->string('side_comment')->nullable()->comment('侧面观备注');
            $table->string('back_comment')->nullable()->comment('背后观图片');
            $table->string('side_summary')->nullable()->comment('侧面观小结');
            $table->string('back_summary')->nullable()->comment('背后观小结');
            $table->timestamps();
            $table->softDeletes();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('fitness_form');
    }
}
